Connect option
Use the Database
Connect menu option to connect to an existing database. After choosing the Connect option the Database Connect dialog box, as shown in Table 8–3, appears. Note that the Database Connect dialog box also appears after you create a database using the Database Create menu option.
The Database Connect dialog box contains the following fields:
- Physical Name
- Logical Name
- Database Type
- Multiple Users
- Userid
- Password
- Trigger Location
- Parameter File
- Other CONNECT Statement Parameters
Specifies the actual name of the database on a disk. This name can contain an explicit path or it can be relative to your propath.
Specifies the database name that references a connected physical database. For example, if the physical database name is mydb1.db, the default logical database name is mydb1.
Specifies the database type. By default, the database type is Progress.
Specifies if you want multiple users to be able to access this database at the same time. The default is single-user. An x indicates multiple users can access the database. Before you can connect to a multi-user database, you must start a server for it using the PROSERVE utility.
Note: You must select this option if you are running a multi-user server and you want to connect to a self-service client.Identifies your user ID. Whether you enter a user ID and password depends on how you initially created the database. If you created a new database from an empty or the SPORTS database, then you don’t have to enter any values for user ID or password because, by default, the security for these databases is not enabled. However, if you created a database from a copy of another database that has a list of user IDs and passwords in the user list, then you must specify a valid user ID and password.
The Data Dictionary searches for the entered identification and passwords and if a match is found in the user list, it assigns the user ID to the new session. Otherwise, you will not be allowed you to connect to the database. For more information on user IDs and passwords, see OpenEdge Data Management: Database Administration .
Identifies your password.
Specifies the directory or r-code library containing the trigger code for the database.
Specifies the parameter filename that contains the startup parameters for the database. The parameter file can include any number of startup parameters. For more information about parameter files, see OpenEdge Data Management: Database Administration and OpenEdge Deployment: Managing 4GL Applications .
Specifies any other startup parameters for the database that are not included in the parameter file. For example, enter any parameters you want to use that are not defined by this dialog box (or by the parameter file, if you included one in the Parameter File area).
Internally, the Data Dictionary constructs and executes a CONNECT statement using the information you supply. Therefore, any rules that apply to the CONNECT statement also apply to database connections using the Data Dictionary. See OpenEdge Development: Progress 4GL Handbook for more information about the CONNECT statement. For more information about connection parameters, see OpenEdge Deployment: Startup Command and Parameter Reference .